create table sys_user_post
(
    user_id bigint not null,
    post_id bigint not null,
    primary key (user_id, post_id)
)
go

exec sp_addextendedproperty 'MS_Description', '用户与岗位关联表', 'SCHEMA', 'dbo', 'TABLE', 'sys_user_post'
go

exec sp_addextendedproperty 'MS_Description', '用户ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_user_post', 'COLUMN', 'user_id'
go

exec sp_addextendedproperty 'MS_Description', '岗位ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_user_post', 'COLUMN', 'post_id'
go

INSERT INTO [ry-vue].dbo.sys_user_post (user_id, post_id) VALUES (1, 1);
INSERT INTO [ry-vue].dbo.sys_user_post (user_id, post_id) VALUES (2, 2);